set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[CSP_UpdateMarketPlace] 
@ItemID int,
@IsActive bit,
@AdminComment nvarchar(400),
@MarketContent nvarchar(400),
@ShowContactInfo bit

AS
BEGIN
	
	SET NOCOUNT ON;
	UPDATE TblMarket
	SET IsActive=@IsActive,
	AdminComment=@AdminComment,
	MarketContent=@MarketContent,
	ShowContactInfo=@ShowContactInfo
	WHERE ItemID=@ItemID

DECLARE @ReturnVal Int
SET @ReturnVal=@@ROWCOUNT
Return @ReturnVal
END